package com.xinjiang.electricpower.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.xinjiang.electricpower.domain.OrgManagerInfo;
import com.xinjiang.electricpower.domain.vo.OrgConfigVO;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @author feizhao
 * @date 2022/12/7
 * @apiNote
 */
public interface OrgManagerInfoMapper extends BaseMapper<OrgManagerInfo> {

    @Select("select so.org_name," +
            "so.org_no," +
            "omi.users," +
            "omi.employees," +
            "omi.manage_common_variable," +
            "omi.mange_specific_variable " +
            "from sys_org so ,sys_org_info soi , org_manager_info omi" +
            " where so.org_no=soi.org_no and omi.org_no= so.org_no")
    List<OrgConfigVO> selectOrgConfigList();

}
